<%@page import="org.blackjuly.sign.entity.Period"%>
<%@page import="org.blackjuly.sign.entity.Month"%>
<%@page import="org.blackjuly.sign.service.PeriodService"%>
<%@page import="org.blackjuly.sign.data.SystemDataSource"%>
<%@page import="java.sql.Connection"%>
<%@page import="org.blackjuly.sign.service.MonthService"%>
<%@page language="java" pageEncoding="utf-8"%>
<%@include file="auth.jsp"%>

<%

MonthService monthService = new MonthService();
Connection conn1 = SystemDataSource.getInstance().getConnection();
monthService.setConnection(conn1);

PeriodService periodService = new PeriodService();
Connection conn2 = SystemDataSource.getInstance().getConnection();
periodService.setConnection(conn2);

%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<style type="text/css">.w3cbbs { page-break-after:always;}
</style>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>家长会汇报材料</title>
</head>

<body>
<%
for(Long id = 1L ; id <= 61L ; id++){
	Month month = monthService.findGradeById(id);
	Period period = periodService.findGradeById(id);
%>
<h1><p align="center">苏仙中学230班九年级上期家长会 <br />
  汇  报 材 料 <br /></p></h1>
  <p><strong><%=month.getStudent() %></strong>同学家长:
  <br /> 
<strong>&nbsp;&nbsp;&nbsp;您好！</strong>
  <strong>感谢您在百忙之中抽出时间来参加孩子的家长会，您们的到来，让您的孩子感受到父母的浓浓的爱，祝您的孩子在这份厚爱的滋润下茁壮成长！ </strong></p>
  <strong>一、孩子的基本情况： </strong>
<table border="1" cellspacing="0" cellpadding="0" align="center">
  <tr>
    <td rowspan="3"><p align="center"><strong>期中考试成绩 </strong></p></td>
    <td><p align="center"><strong>语文 </strong></p></td>
    <td><p align="center"><strong>数学 </strong></p></td>
    <td><p align="center"><strong>英语 </strong></p></td>
    <td><p align="center"><strong>历史 </strong></p></td>
    <td><p align="center"><strong>政治 </strong></p></td>
    <td><p align="center"><strong>物理 </strong></p></td>
    <td><p align="center"><strong>化学 </strong></p></td>
    <td><p align="center"><strong>总分</strong></p></td>
    <td colspan="2"><p align="center"><strong>班名</strong></p></td>
    <td><p align="center"><strong>校名 </strong></p></td>
    <td><p align="center"><strong>对比上次期中 </strong></p></td>
  </tr>
  <tr>
    <td><p align="center"><strong><%=period.getChinese() %></strong></p></td>
    <td><p align="center"><strong><%=period.getMath() %></strong></p></td>
    <td><p align="center"><strong><%=period.getEnglish() %></strong></p></td>
    <td><p align="center"><strong><%=period.getHistory() %></strong></p></td>
    <td><p align="center"><strong><%=period.getPolitics() %></strong></p></td>
    <td><p align="center"><strong><%=period.getPhysics() %></strong></p></td>
    <td><p align="center"><strong><%=period.getChemistry() %></strong></p></td>
    <td rowspan="2"><p align="center"><strong><%=period.getAll() %></strong></p>      </td>
    <td colspan="2" rowspan="2"><p align="center"><strong><%=period.getA() %></strong></p>      </td>
    <td rowspan="2"><p align="center"><strong></strong><strong><%=period.getReaking() %></strong></p>      </td>
    <td rowspan="2"><p align="center"><strong><%=period.getContrast() %></strong></p>      </td>
  </tr>
  <tr>
    <td><p align="center"><strong></strong><%=period.getGrade1() %></p></td>
    <td><p align="center"><strong><%=period.getGrade2() %></strong></p></td>
    <td><p align="center"><%=period.getGrade3() %></p></td>
    <td><p align="center"><%=period.getGrade4() %></p></td>
    <td><p align="center"><%=period.getGrade5() %></p></td>
    <td><p align="center"><%=period.getGrade6() %></p></td>
    <td><p align="center"><%=period.getGrade7() %></p></td>
  </tr>
  <tr>
    <td rowspan="3"><p align="center"><strong>第一次月考 </strong></p></td>
    <td><p align="center"><strong>语文 </strong></p></td>
    <td><p align="center"><strong>数学 </strong></p></td>
    <td><p align="center"><strong>英语 </strong></p></td>
    <td><p align="center"><strong>历史 </strong></p></td>
    <td><p align="center"><strong>政治 </strong></p></td>
    <td><p align="center"><strong>物理 </strong></p></td>
    <td><p align="center"><strong>化学 </strong></p></td>
    <td><p align="center"><strong>总分 </strong></p></td>
    <td colspan="2"><p align="center"><strong>班名 </strong></p></td>
    <td><p align="center"><strong>校名 </strong></p></td>
    <td><p align="center"><strong>对比上次月考 </strong></p></td>
  </tr>
  <tr>
    <td><p align="center"><strong><%=month.getChinese() %></strong></p></td>
    <td><p align="center"><strong><%=month.getMath() %></strong></p></td>
    <td><p align="center"><strong><%=month.getEnglish() %></strong></p></td>
    <td><p align="center"><strong><%=month.getHistory() %></strong></p></td>
    <td><p align="center"><strong><%=month.getPolitics() %></strong></p></td>
    <td><p align="center"><strong><%=month.getPhysics() %></strong></p></td>
    <td><p align="center"><strong><%=month.getChemistry() %></strong></p></td>
    <td rowspan="2"><p align="center"><strong><%=month.getAll() %></strong></p>      </td>
    <td colspan="2" rowspan="2"><p align="center"><strong><%=month.getA() %></strong></p>      </td>
    <td rowspan="2"><p align="center"><strong></strong><strong><%=month.getReaking() %></strong></p>      </td>
    <td rowspan="2"><p align="center"><strong><%=month.getContrast() %></strong></p>      </td>
  </tr>
  <tr>
    <td><p align="center"><strong></strong><%=month.getGrade1() %></p></td>
    <td><p align="center"><strong><%=month.getGrade2() %></strong></p></td>
    <td><p align="center"><%=month.getGrade3() %></p></td>
    <td><p align="center"><%=month.getGrade4() %></p></td>
    <td><p align="center"><%=month.getGrade5() %></p></td>
    <td><p align="center"><%=month.getGrade6() %></p></td>
    <td><p align="center"><%=month.getGrade7() %></p></td>
  </tr>
  <tr>
    <td><p align="center"><strong>操行分 </strong></p></td>
    <td colspan="7"><p align="center"><strong>9</strong><strong>月得分:____；10月得分:____</strong></p></td>
    <td colspan="2"><p align="center"><strong>食堂消费次数:____次 </strong></p></td>
    <td colspan="3"><p align="center"><strong>食堂消费总金额:____元 </strong><br />
    </p></td>
  </tr>
</table>
<p align="left"><strong>二、孩子，我想对你说： </strong></p>
<table border="1" cellspacing="0" cellpadding="0" align="center">
  <tr>
    <td width="574" valign="top"><p align="left"><strong>&nbsp;</strong></p>
      <p align="left">&nbsp;</p>
      <p align="left">&nbsp;</p>
      <p align="left">&nbsp;</p>
      <p align="left">&nbsp;</p>
      <p align="left">&nbsp;</p>
      <p align="left">&nbsp;</p>
      <p align="left">&nbsp;</p></td>
  </tr>
</table>
<p align="right"><strong>230班班委会 </strong><br />
    <strong>2016年11月20日 </strong></p>
   	<p class="w3cbbs"></p>
<%
}
%>
</body>
</html>
